www.gusucode.com > ROCKOA PHP协同办公OA办公系统 v2.0PHP源码程序 > ROCKOA PHP协同办公OA办公系统 v2.0/rockoa_v2.0/rockoa_v2.0/webrock/work/work/workhAction.php
<?php class workhClassAction extends Action { public function gettodayAjax() { $rows = array(); $dt = $this->date; $uid = $this->adminid; //今日工作任务 $where = "`dt`='$dt' and mid>0 and instr(concat(',', distid, ','), ',$uid,')>0 order by `startdt`"; $rows = m('work')->getall($where,'`type`,`title`,`state`,`startdt`'); foreach($rows as $k=>$rs){ $rows[$k]['tabsnum'] = 'worklist'; $rows[$k]['tabstitle'] = '今日任务'; $rows[$k]['tabsurl'] = 'work,work,list,atype=0'; } //今日会议 $marr = m('meet')->getmeet($dt, $uid); foreach($marr as $k=>$rs){ $marr[$k]['tabsnum'] = 'meetapply'; $marr[$k]['tabstitle'] = '会议室预定'; $marr[$k]['tabsurl'] = 'humanres,meet,apply'; } $rows = array_merge($rows, $marr); //日程事务 $marr = m('schedule')->getdtarr($dt, $uid); foreach($marr as $k=>$rs){ $_rs['type'] = '日程事务'; $_rs['title'] = $rs['title']; $s1 = $s2 = $s = ''; if($this->contain($rs['startdt'], $dt)){ $dsts= explode(' ', $rs['startdt']); $s1 = $dsts[1]; }else{ $s1 = '00:00:00'; } if($this->contain($rs['enddt'], $dt)){ $dsts= explode(' ', $rs['startdt']); $s=''.$s1.'至'.$dsts[1].''; }else if(!$this->isempt($rs['enddt'])){ $s=''.$s1.'至23:59:59'; }else{ $s='今日'.$s1.''; } $_rs['startdt']= $s; $_rs['tabsnum'] = 'schedule'; $_rs['tabstitle'] = '日程事务'; $_rs['tabsurl'] = 'person,schedule'; $rows[] = $_rs; } //项目的 $urs = m('admin')->getone($this->adminid, 'deptid,id'); $s = "and (".$this->rock->dbinstr('runuserid', 'd'.$urs['deptid'])." or ".$this->rock->dbinstr('runuserid', 'u'.$urs['id']).") and `state`<>'已完成'"; $marr = m('projectm')->getall("1 $s order by `id` desc", '`typename`,`startdt`,`state`,`progress`,`title`'); $dbobj = c('date', true); foreach($marr as $k=>$rs){ $_rs['type'] = $rs['typename']; $_rs['title'] = $rs['title']; $_rs['state'] = $rs['state'].'('.$rs['progress'].'%)'; $dtss = explode(' ', $rs['startdt']); $jgts = $dbobj->datediff('d', $dtss[0], $this->date); $_rs['startdt'] = $dtss[0].'(执行'.$jgts.'天)'; $_rs['tabsnum'] = 'projectbg'; $_rs['tabstitle'] = '项目进度报告'; $_rs['tabsurl'] = 'project,project,list,atype=bg'; $rows[] = $_rs; } foreach($rows as $k=>$rs){ $rows[$k]['xuhao'] = $k+1; } if(count($rows)==0){ $rows[] = array( 'title' => '<div style="font-size:16px;height:40px;line-height:35px">无信息</div>', 'xuhao' => '' ); } echo json_encode(array('rows'=>$rows,'totalCount'=>count($rows))); } }